Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 5571 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 247.7 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 19 |
HCPCS_CODE has a high cardinality: 561 distinct values | High cardinality |
COUNTY has a high cardinality: 297 distinct values | High cardinality |
CODE has a high cardinality: 1023 distinct values | High cardinality |
PROCEDURE_CODE has a high cardinality: 135 distinct values | High cardinality |
PROCEDURE_DESCRIPTION has a high cardinality: 122 distinct values | High cardinality |
APPROVED_CHARGE is highly overall correlated with TOTAL_CHARGES | High correlation |
REASON_CODE is highly overall correlated with CLAIM_STATUS and 1 other fields | High correlation |
Age is highly overall correlated with MEDICARE_STATUS | High correlation |
TOTAL_CHARGES is highly overall correlated with APPROVED_CHARGE | High correlation |
ENCOUNTER_TYPE is highly overall correlated with PLACE_OF_SERVICE_CODE | High correlation |
CLAIM_STATUS is highly overall correlated with REASON_CODE and 1 other fields | High correlation |
DENIAL_CATEGORY is highly overall correlated with REASON_CODE and 1 other fields | High correlation |
PLACE_OF_SERVICE_CODE is highly overall correlated with ENCOUNTER_TYPE and 1 other fields | High correlation |
MEDICARE_STATUS is highly overall correlated with Age | High correlation |
ADMIT_TYPE_CODE is highly overall correlated with PLACE_OF_SERVICE_CODE | High correlation |
BILL_TYPE_CODE is highly imbalanced (54.8%) | Imbalance |
RACE is highly imbalanced (68.3%) | Imbalance |
APPROVED_CHARGE has 56 (1.0%) zeros | Zeros |
TOTAL_CHARGES has 56 (1.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-08 16:28:49.120913 |
|---|---|
| Analysis finished | 2023-05-08 16:28:58.440178 |
| Duration | 9.32 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
APPROVED_CHARGE
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 2867 |
|---|---|
| Distinct (%) | 51.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1736.9049 |
| Minimum | -82.7 |
|---|---|
| Maximum | 28868.84 |
| Zeros | 56 |
| Zeros (%) | 1.0% |
| Negative | 28 |
| Negative (%) | 0.5% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | -82.7 |
|---|---|
| 5-th percentile | 13.86 |
| Q1 | 53.17 |
| median | 252.46 |
| Q3 | 1764.945 |
| 95-th percentile | 8062.57 |
| Maximum | 28868.84 |
| Range | 28951.54 |
| Interquartile range (IQR) | 1711.775 |
Descriptive statistics
| Standard deviation | 3128.3475 |
|---|---|
| Coefficient of variation (CV) | 1.8011047 |
| Kurtosis | 12.147919 |
| Mean | 1736.9049 |
| Median Absolute Deviation (MAD) | 227.35 |
| Skewness | 2.9423478 |
| Sum | 9676297 |
| Variance | 9786558.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 56 | 1.0% |
| 7902.57 | 13 | 0.2% |
| 6667.57 | 13 | 0.2% |
| 8062.57 | 11 | 0.2% |
| 3659.73 | 11 | 0.2% |
| 1251.77 | 10 | 0.2% |
| 4.75 | 10 | 0.2% |
| 7827.07 | 10 | 0.2% |
| 1878.39 | 10 | 0.2% |
| 3649.63 | 10 | 0.2% |
| Other values (2857) | 5417 |
| Value | Count | Frequency (%) |
| -82.7 | 2 | |
| -56.55 | 2 | |
| -37.1 | 2 | |
| -36.43 | 2 | |
| -35.34 | 2 | |
| -35.11 | 1 | |
| -32.96 | 1 | |
| -29.51 | 2 | |
| -27.05 | 2 | |
| -26.92 | 1 |
| Value | Count | Frequency (%) |
| 28868.84 | 1 | < 0.1% |
| 27601.81 | 4 | |
| 26996.61 | 2 | |
| 26486.41 | 2 | |
| 26052.21 | 1 | < 0.1% |
| 19788.96 | 3 | |
| 19564.46 | 2 | |
| 19474.36 | 2 | |
| 19398.86 | 2 | |
| 16367.48 | 2 |
REASON_CODE
Real number (ℝ)
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.439957 |
| Minimum | 1 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 22 |
| 95-th percentile | 115 |
| Maximum | 118 |
| Range | 117 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 36.800624 |
|---|---|
| Coefficient of variation (CV) | 1.8004257 |
| Kurtosis | 1.6558012 |
| Mean | 20.439957 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8072404 |
| Sum | 113871 |
| Variance | 1354.2859 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3682 | |
| 115 | 320 | 5.7% |
| 29 | 314 | 5.6% |
| 90 | 311 | 5.6% |
| 32 | 34 | 0.6% |
| 12 | 30 | 0.5% |
| 5 | 30 | 0.5% |
| 7 | 30 | 0.5% |
| 6 | 30 | 0.5% |
| 4 | 30 | 0.5% |
| Other values (26) | 760 | 13.6% |
| Value | Count | Frequency (%) |
| 1 | 3682 | |
| 4 | 30 | 0.5% |
| 5 | 30 | 0.5% |
| 6 | 30 | 0.5% |
| 7 | 30 | 0.5% |
| 8 | 29 | 0.5% |
| 9 | 30 | 0.5% |
| 10 | 30 | 0.5% |
| 11 | 30 | 0.5% |
| 12 | 30 | 0.5% |
| Value | Count | Frequency (%) |
| 118 | 28 | 0.5% |
| 117 | 29 | 0.5% |
| 116 | 29 | 0.5% |
| 115 | 320 | |
| 114 | 28 | 0.5% |
| 112 | 29 | 0.5% |
| 111 | 29 | 0.5% |
| 90 | 311 | |
| 76 | 29 | 0.5% |
| 74 | 29 | 0.5% |
Age
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.418955 |
| Minimum | 19 |
|---|---|
| Maximum | 104 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 55 |
| Q1 | 71 |
| median | 76 |
| Q3 | 84 |
| 95-th percentile | 94 |
| Maximum | 104 |
| Range | 85 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 12.533418 |
|---|---|
| Coefficient of variation (CV) | 0.16400928 |
| Kurtosis | 2.8298925 |
| Mean | 76.418955 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | -0.99749688 |
| Sum | 425730 |
| Variance | 157.08656 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 74 | 386 | 6.9% |
| 72 | 369 | 6.6% |
| 73 | 334 | 6.0% |
| 79 | 283 | 5.1% |
| 90 | 235 | 4.2% |
| 77 | 217 | 3.9% |
| 84 | 212 | 3.8% |
| 75 | 205 | 3.7% |
| 71 | 205 | 3.7% |
| 69 | 204 | 3.7% |
| Other values (50) | 2921 |
| Value | Count | Frequency (%) |
| 19 | 30 | 0.5% |
| 38 | 80 | |
| 39 | 19 | 0.3% |
| 42 | 35 | |
| 43 | 15 | 0.3% |
| 44 | 9 | 0.2% |
| 45 | 18 | 0.3% |
| 47 | 2 | < 0.1% |
| 49 | 13 | 0.2% |
| 50 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 104 | 38 | 0.7% |
| 101 | 22 | 0.4% |
| 100 | 8 | 0.1% |
| 99 | 71 | |
| 98 | 30 | 0.5% |
| 97 | 7 | 0.1% |
| 96 | 33 | 0.6% |
| 95 | 34 | 0.6% |
| 94 | 114 | |
| 93 | 78 |
SERVICE_UNIT_QUANTITY
Real number (ℝ)
| Distinct | 98 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8427571 |
| Minimum | 0 |
|---|---|
| Maximum | 510 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 12 |
| Maximum | 510 |
| Range | 510 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 20.989115 |
|---|---|
| Coefficient of variation (CV) | 4.3341251 |
| Kurtosis | 131.2897 |
| Mean | 4.8427571 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.6802388 |
| Sum | 26979 |
| Variance | 440.54295 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4399 | |
| 2 | 399 | 7.2% |
| 3 | 142 | 2.5% |
| 4 | 135 | 2.4% |
| 5 | 51 | 0.9% |
| 6 | 50 | 0.9% |
| 20 | 29 | 0.5% |
| 100 | 29 | 0.5% |
| 10 | 28 | 0.5% |
| 8 | 27 | 0.5% |
| Other values (88) | 282 | 5.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 4399 | |
| 2 | 399 | 7.2% |
| 3 | 142 | 2.5% |
| 4 | 135 | 2.4% |
| 5 | 51 | 0.9% |
| 6 | 50 | 0.9% |
| 7 | 24 | 0.4% |
| 8 | 27 | 0.5% |
| 9 | 10 | 0.2% |
| Value | Count | Frequency (%) |
| 510 | 1 | |
| 340 | 1 | |
| 321 | 1 | |
| 300 | 1 | |
| 296 | 1 | |
| 280 | 1 | |
| 266 | 1 | |
| 244 | 1 | |
| 240 | 1 | |
| 205 | 1 |
TOTAL_CHARGES
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 3155 |
|---|---|
| Distinct (%) | 56.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1783.3414 |
| Minimum | -36.43 |
|---|---|
| Maximum | 28868.84 |
| Zeros | 56 |
| Zeros (%) | 1.0% |
| Negative | 8 |
| Negative (%) | 0.1% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | -36.43 |
|---|---|
| 5-th percentile | 27.84 |
| Q1 | 108.62 |
| median | 343.33 |
| Q3 | 1786.52 |
| 95-th percentile | 8157.07 |
| Maximum | 28868.84 |
| Range | 28905.27 |
| Interquartile range (IQR) | 1677.9 |
Descriptive statistics
| Standard deviation | 3116.1498 |
|---|---|
| Coefficient of variation (CV) | 1.7473658 |
| Kurtosis | 12.295841 |
| Mean | 1783.3414 |
| Median Absolute Deviation (MAD) | 296.8 |
| Skewness | 2.9589874 |
| Sum | 9934995 |
| Variance | 9710389.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 56 | 1.0% |
| 7902.57 | 13 | 0.2% |
| 6667.57 | 13 | 0.2% |
| 8062.57 | 11 | 0.2% |
| 3659.73 | 11 | 0.2% |
| 3649.63 | 10 | 0.2% |
| 1878.39 | 10 | 0.2% |
| 1192.27 | 9 | 0.2% |
| 9422.86 | 9 | 0.2% |
| 8217.17 | 9 | 0.2% |
| Other values (3145) | 5420 |
| Value | Count | Frequency (%) |
| -36.43 | 2 | < 0.1% |
| -35.11 | 1 | < 0.1% |
| -32.96 | 1 | < 0.1% |
| -26.92 | 1 | < 0.1% |
| -25.92 | 1 | < 0.1% |
| -24.3 | 1 | < 0.1% |
| -21.77 | 1 | < 0.1% |
| 0 | 56 | |
| 0.35 | 1 | < 0.1% |
| 2.47 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 28868.84 | 1 | < 0.1% |
| 27782.81 | 2 | |
| 27601.81 | 2 | |
| 26996.61 | 2 | |
| 26486.41 | 2 | |
| 26052.21 | 1 | < 0.1% |
| 19788.96 | 3 | |
| 19564.46 | 2 | |
| 19474.36 | 2 | |
| 19398.86 | 2 |
BILL_TYPE_CODE
Categorical
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 131 | |
|---|---|
| 111 | |
| 141 | |
| 13I | 254 |
| 851 | 243 |
| Other values (23) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 16713 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 131 |
|---|---|
| 2nd row | 131 |
| 3rd row | 131 |
| 4th row | 131 |
| 5th row | 131 |
Common Values
| Value | Count | Frequency (%) |
| 131 | 3381 | |
| 111 | 735 | 13.2% |
| 141 | 391 | 7.0% |
| 13I | 254 | 4.6% |
| 851 | 243 | 4.4% |
| 137 | 208 | 3.7% |
| 117 | 45 | 0.8% |
| 133 | 40 | 0.7% |
| 132 | 40 | 0.7% |
| 11I | 34 | 0.6% |
| Other values (18) | 200 | 3.6% |
Length
| Value | Count | Frequency (%) |
| 131 | 3381 | |
| 111 | 735 | 13.2% |
| 141 | 391 | 7.0% |
| 13i | 254 | 4.6% |
| 851 | 243 | 4.4% |
| 137 | 208 | 3.7% |
| 117 | 45 | 0.8% |
| 133 | 40 | 0.7% |
| 132 | 40 | 0.7% |
| 11i | 34 | 0.6% |
| Other values (18) | 200 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 10851 | |
| 3 | 4032 | 24.1% |
| 4 | 413 | 2.5% |
| 7 | 336 | 2.0% |
| 8 | 326 | 2.0% |
| I | 319 | 1.9% |
| 5 | 301 | 1.8% |
| 2 | 89 | 0.5% |
| 0 | 26 | 0.2% |
| 9 | 20 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 16394 | |
| Uppercase Letter | 319 | 1.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 10851 | |
| 3 | 4032 | 24.6% |
| 4 | 413 | 2.5% |
| 7 | 336 | 2.0% |
| 8 | 326 | 2.0% |
| 5 | 301 | 1.8% |
| 2 | 89 | 0.5% |
| 0 | 26 | 0.2% |
| 9 | 20 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 319 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 16394 | |
| Latin | 319 | 1.9% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 10851 | |
| 3 | 4032 | 24.6% |
| 4 | 413 | 2.5% |
| 7 | 336 | 2.0% |
| 8 | 326 | 2.0% |
| 5 | 301 | 1.8% |
| 2 | 89 | 0.5% |
| 0 | 26 | 0.2% |
| 9 | 20 | 0.1% |
Latin
| Value | Count | Frequency (%) |
| I | 319 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16713 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 10851 | |
| 3 | 4032 | 24.1% |
| 4 | 413 | 2.5% |
| 7 | 336 | 2.0% |
| 8 | 326 | 2.0% |
| I | 319 | 1.9% |
| 5 | 301 | 1.8% |
| 2 | 89 | 0.5% |
| 0 | 26 | 0.2% |
| 9 | 20 | 0.1% |
HCPCS_CODE
Categorical
| Distinct | 561 |
|---|---|
| Distinct (%) | 10.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 36415 | 324 |
|---|---|
| G0463 | 228 |
| 80053 | 176 |
| 85025 | 173 |
| Q0510 | 149 |
| Other values (556) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.0001795 |
| Min length | 1 |
Characters and Unicode
| Total characters | 27856 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 173 ? |
|---|---|
| Unique (%) | 3.1% |
Sample
| 1st row | 82306 |
|---|---|
| 2nd row | J1644 |
| 3rd row | 76642 |
| 4th row | 85610 |
| 5th row | G0463 |
Common Values
| Value | Count | Frequency (%) |
| 36415 | 324 | 5.8% |
| G0463 | 228 | 4.1% |
| 80053 | 176 | 3.2% |
| 85025 | 173 | 3.1% |
| Q0510 | 149 | 2.7% |
| 80061 | 132 | 2.4% |
| 80048 | 118 | 2.1% |
| 84443 | 110 | 2.0% |
| A9270 | 109 | 2.0% |
| 97110 | 91 | 1.6% |
| Other values (551) | 3961 |
Length
| Value | Count | Frequency (%) |
| 36415 | 324 | 5.8% |
| g0463 | 228 | 4.1% |
| 80053 | 176 | 3.2% |
| 85025 | 173 | 3.1% |
| q0510 | 149 | 2.7% |
| 80061 | 132 | 2.4% |
| 80048 | 118 | 2.1% |
| 84443 | 110 | 2.0% |
| a9270 | 109 | 2.0% |
| 97110 | 91 | 1.6% |
| Other values (551) | 3961 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4912 | |
| 8 | 3275 | |
| 3 | 2551 | |
| 9 | 2404 | |
| 5 | 2356 | |
| 1 | 2344 | |
| 4 | 2287 | |
| 7 | 2151 | |
| 6 | 2118 | |
| 2 | 1959 | 7.0% |
| Other values (12) | 1499 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 26357 | |
| Uppercase Letter | 1499 | 5.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 481 | |
| A | 300 | |
| J | 278 | |
| Q | 245 | |
| C | 79 | 5.3% |
| P | 53 | 3.5% |
| Z | 38 | 2.5% |
| S | 10 | 0.7% |
| L | 9 | 0.6% |
| V | 3 | 0.2% |
| Other values (2) | 3 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4912 | |
| 8 | 3275 | |
| 3 | 2551 | |
| 9 | 2404 | |
| 5 | 2356 | |
| 1 | 2344 | |
| 4 | 2287 | |
| 7 | 2151 | |
| 6 | 2118 | |
| 2 | 1959 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 26357 | |
| Latin | 1499 | 5.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 481 | |
| A | 300 | |
| J | 278 | |
| Q | 245 | |
| C | 79 | 5.3% |
| P | 53 | 3.5% |
| Z | 38 | 2.5% |
| S | 10 | 0.7% |
| L | 9 | 0.6% |
| V | 3 | 0.2% |
| Other values (2) | 3 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 4912 | |
| 8 | 3275 | |
| 3 | 2551 | |
| 9 | 2404 | |
| 5 | 2356 | |
| 1 | 2344 | |
| 4 | 2287 | |
| 7 | 2151 | |
| 6 | 2118 | |
| 2 | 1959 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27856 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4912 | |
| 8 | 3275 | |
| 3 | 2551 | |
| 9 | 2404 | |
| 5 | 2356 | |
| 1 | 2344 | |
| 4 | 2287 | |
| 7 | 2151 | |
| 6 | 2118 | |
| 2 | 1959 | 7.0% |
| Other values (12) | 1499 | 5.4% |
GENDER
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| female | |
|---|---|
| male |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.1807575 |
| Min length | 4 |
Characters and Unicode
| Total characters | 28862 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | male |
|---|---|
| 2nd row | female |
| 3rd row | female |
| 4th row | male |
| 5th row | male |
Common Values
| Value | Count | Frequency (%) |
| female | 3289 | |
| male | 2282 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 3289 | |
| male | 2282 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8860 | |
| m | 5571 | |
| a | 5571 | |
| l | 5571 | |
| f | 3289 | 11.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28862 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8860 | |
| m | 5571 | |
| a | 5571 | |
| l | 5571 | |
| f | 3289 | 11.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 28862 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8860 | |
| m | 5571 | |
| a | 5571 | |
| l | 5571 | |
| f | 3289 | 11.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28862 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8860 | |
| m | 5571 | |
| a | 5571 | |
| l | 5571 | |
| f | 3289 | 11.4% |
RACE
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| white | |
|---|---|
| black | |
| hispanic | 141 |
| other | 76 |
| asian | 63 |
| Other values (2) | 62 |
Length
| Max length | 21 |
|---|---|
| Median length | 5 |
| Mean length | 5.1057261 |
| Min length | 5 |
Characters and Unicode
| Total characters | 28444 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | white |
|---|---|
| 2nd row | white |
| 3rd row | white |
| 4th row | white |
| 5th row | white |
Common Values
| Value | Count | Frequency (%) |
| white | 4710 | |
| black | 519 | 9.3% |
| hispanic | 141 | 2.5% |
| other | 76 | 1.4% |
| asian | 63 | 1.1% |
| unknown | 59 | 1.1% |
| north american native | 3 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| white | 4710 | |
| black | 519 | 9.3% |
| hispanic | 141 | 2.5% |
| other | 76 | 1.4% |
| asian | 63 | 1.1% |
| unknown | 59 | 1.1% |
| north | 3 | 0.1% |
| american | 3 | 0.1% |
| native | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 5061 | |
| h | 4930 | |
| t | 4792 | |
| e | 4792 | |
| w | 4769 | |
| a | 795 | 2.8% |
| c | 663 | 2.3% |
| k | 578 | 2.0% |
| l | 519 | 1.8% |
| b | 519 | 1.8% |
| Other values (9) | 1026 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28438 | |
| Space Separator | 6 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 5061 | |
| h | 4930 | |
| t | 4792 | |
| e | 4792 | |
| w | 4769 | |
| a | 795 | 2.8% |
| c | 663 | 2.3% |
| k | 578 | 2.0% |
| l | 519 | 1.8% |
| b | 519 | 1.8% |
| Other values (8) | 1020 | 3.6% |
Space Separator
| Value | Count | Frequency (%) |
| 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 28438 | |
| Common | 6 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 5061 | |
| h | 4930 | |
| t | 4792 | |
| e | 4792 | |
| w | 4769 | |
| a | 795 | 2.8% |
| c | 663 | 2.3% |
| k | 578 | 2.0% |
| l | 519 | 1.8% |
| b | 519 | 1.8% |
| Other values (8) | 1020 | 3.6% |
Common
| Value | Count | Frequency (%) |
| 6 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28444 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 5061 | |
| h | 4930 | |
| t | 4792 | |
| e | 4792 | |
| w | 4769 | |
| a | 795 | 2.8% |
| c | 663 | 2.3% |
| k | 578 | 2.0% |
| l | 519 | 1.8% |
| b | 519 | 1.8% |
| Other values (9) | 1026 | 3.6% |
STATE
Categorical
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| California | |
|---|---|
| Texas | |
| Florida | |
| Michigan | 332 |
| Indiana | 278 |
| Other values (43) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 8.3819781 |
| Min length | 2 |
Characters and Unicode
| Total characters | 46696 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North Carolina |
|---|---|
| 2nd row | Utah |
| 3rd row | Delaware |
| 4th row | Connecticut |
| 5th row | Iowa |
Common Values
| Value | Count | Frequency (%) |
| California | 412 | 7.4% |
| Texas | 410 | 7.4% |
| Florida | 406 | 7.3% |
| Michigan | 332 | 6.0% |
| Indiana | 278 | 5.0% |
| Ohio | 235 | 4.2% |
| Pennsylvania | 230 | 4.1% |
| North Carolina | 211 | 3.8% |
| New York | 198 | 3.6% |
| New Jersey | 181 | 3.2% |
| Other values (38) | 2678 |
Length
| Value | Count | Frequency (%) |
| new | 425 | 6.7% |
| california | 412 | 6.5% |
| texas | 410 | 6.4% |
| florida | 406 | 6.4% |
| michigan | 332 | 5.2% |
| carolina | 312 | 4.9% |
| indiana | 278 | 4.4% |
| ohio | 235 | 3.7% |
| pennsylvania | 230 | 3.6% |
| north | 211 | 3.3% |
| Other values (41) | 3118 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6050 | |
| i | 5421 | 11.6% |
| n | 4441 | 9.5% |
| s | 3453 | 7.4% |
| o | 3346 | 7.2% |
| e | 2901 | 6.2% |
| r | 2409 | 5.2% |
| l | 2044 | 4.4% |
| h | 1457 | 3.1% |
| t | 1263 | 2.7% |
| Other values (36) | 13911 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 39508 | |
| Uppercase Letter | 6390 | 13.7% |
| Space Separator | 798 | 1.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6050 | |
| i | 5421 | |
| n | 4441 | |
| s | 3453 | |
| o | 3346 | |
| e | 2901 | |
| r | 2409 | 6.1% |
| l | 2044 | 5.2% |
| h | 1457 | 3.7% |
| t | 1263 | 3.2% |
| Other values (14) | 6723 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 927 | |
| C | 845 | |
| N | 757 | |
| I | 618 | |
| T | 547 | |
| O | 447 | |
| F | 406 | 6.4% |
| W | 318 | 5.0% |
| P | 230 | 3.6% |
| Y | 198 | 3.1% |
| Other values (11) | 1097 |
Space Separator
| Value | Count | Frequency (%) |
| 798 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 45898 | |
| Common | 798 | 1.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6050 | |
| i | 5421 | |
| n | 4441 | 9.7% |
| s | 3453 | 7.5% |
| o | 3346 | 7.3% |
| e | 2901 | 6.3% |
| r | 2409 | 5.2% |
| l | 2044 | 4.5% |
| h | 1457 | 3.2% |
| t | 1263 | 2.8% |
| Other values (35) | 13113 |
Common
| Value | Count | Frequency (%) |
| 798 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46696 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6050 | |
| i | 5421 | 11.6% |
| n | 4441 | 9.5% |
| s | 3453 | 7.4% |
| o | 3346 | 7.2% |
| e | 2901 | 6.2% |
| r | 2409 | 5.2% |
| l | 2044 | 4.4% |
| h | 1457 | 3.1% |
| t | 1263 | 2.7% |
| Other values (36) | 13911 |
COUNTY
Categorical
| Distinct | 297 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| Suffolk | 107 |
|---|---|
| Bailey | 106 |
| Cumberland | 103 |
| Palm Beach | 98 |
| La Porte | 93 |
| Other values (292) |
Length
| Max length | 19 |
|---|---|
| Median length | 15 |
| Mean length | 7.4799856 |
| Min length | 3 |
Characters and Unicode
| Total characters | 41671 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Cherokee |
|---|---|
| 2nd row | Summit |
| 3rd row | New Castle |
| 4th row | Fairfield |
| 5th row | Pottawattamie |
Common Values
| Value | Count | Frequency (%) |
| Suffolk | 107 | 1.9% |
| Bailey | 106 | 1.9% |
| Cumberland | 103 | 1.8% |
| Palm Beach | 98 | 1.8% |
| La Porte | 93 | 1.7% |
| Middlesex | 86 | 1.5% |
| Fairfield | 81 | 1.5% |
| King | 80 | 1.4% |
| San Diego | 79 | 1.4% |
| Warrick | 73 | 1.3% |
| Other values (287) | 4665 |
Length
| Value | Count | Frequency (%) |
| san | 154 | 2.4% |
| suffolk | 107 | 1.7% |
| bailey | 106 | 1.7% |
| cumberland | 103 | 1.6% |
| la | 102 | 1.6% |
| beach | 101 | 1.6% |
| palm | 98 | 1.5% |
| lake | 96 | 1.5% |
| porte | 93 | 1.4% |
| middlesex | 86 | 1.3% |
| Other values (308) | 5368 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4364 | 10.5% |
| e | 4093 | 9.8% |
| o | 3134 | 7.5% |
| n | 2746 | 6.6% |
| r | 2612 | 6.3% |
| l | 2458 | 5.9% |
| i | 2338 | 5.6% |
| t | 2013 | 4.8% |
| s | 1697 | 4.1% |
| u | 1102 | 2.6% |
| Other values (41) | 15114 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 34420 | |
| Uppercase Letter | 6398 | 15.4% |
| Space Separator | 843 | 2.0% |
| Dash Punctuation | 10 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4364 | |
| e | 4093 | |
| o | 3134 | 9.1% |
| n | 2746 | 8.0% |
| r | 2612 | 7.6% |
| l | 2458 | 7.1% |
| i | 2338 | 6.8% |
| t | 2013 | 5.8% |
| s | 1697 | 4.9% |
| u | 1102 | 3.2% |
| Other values (15) | 7863 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 867 | |
| S | 774 | |
| B | 584 | |
| M | 553 | 8.6% |
| P | 549 | 8.6% |
| W | 434 | 6.8% |
| L | 422 | 6.6% |
| D | 375 | 5.9% |
| K | 214 | 3.3% |
| H | 210 | 3.3% |
| Other values (14) | 1416 |
Space Separator
| Value | Count | Frequency (%) |
| 843 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 40818 | |
| Common | 853 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4364 | 10.7% |
| e | 4093 | 10.0% |
| o | 3134 | 7.7% |
| n | 2746 | 6.7% |
| r | 2612 | 6.4% |
| l | 2458 | 6.0% |
| i | 2338 | 5.7% |
| t | 2013 | 4.9% |
| s | 1697 | 4.2% |
| u | 1102 | 2.7% |
| Other values (39) | 14261 |
Common
| Value | Count | Frequency (%) |
| 843 | ||
| - | 10 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 41671 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4364 | 10.5% |
| e | 4093 | 9.8% |
| o | 3134 | 7.5% |
| n | 2746 | 6.6% |
| r | 2612 | 6.3% |
| l | 2458 | 5.9% |
| i | 2338 | 5.6% |
| t | 2013 | 4.8% |
| s | 1697 | 4.1% |
| u | 1102 | 2.6% |
| Other values (41) | 15114 |
CODE
Categorical
| Distinct | 1023 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| I10 | 336 |
|---|---|
| E785 | 185 |
| I2510 | 157 |
| E039 | 86 |
| R079 | 84 |
| Other values (1018) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 4.4763956 |
| Min length | 3 |
Characters and Unicode
| Total characters | 24938 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 405 ? |
|---|---|
| Unique (%) | 7.3% |
Sample
| 1st row | G9340 |
|---|---|
| 2nd row | E1142 |
| 3rd row | I480 |
| 4th row | I10 |
| 5th row | I255 |
Common Values
| Value | Count | Frequency (%) |
| I10 | 336 | 6.0% |
| E785 | 185 | 3.3% |
| I2510 | 157 | 2.8% |
| E039 | 86 | 1.5% |
| R079 | 84 | 1.5% |
| K219 | 80 | 1.4% |
| Z79899 | 70 | 1.3% |
| E119 | 68 | 1.2% |
| Z7982 | 60 | 1.1% |
| Z1231 | 60 | 1.1% |
| Other values (1013) | 4385 |
Length
| Value | Count | Frequency (%) |
| i10 | 336 | 6.0% |
| e785 | 185 | 3.3% |
| i2510 | 157 | 2.8% |
| e039 | 86 | 1.5% |
| r079 | 84 | 1.5% |
| k219 | 80 | 1.4% |
| z79899 | 70 | 1.3% |
| e119 | 68 | 1.2% |
| z1231 | 60 | 1.1% |
| z7982 | 60 | 1.1% |
| Other values (1013) | 4385 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3202 | |
| 0 | 2980 | |
| 9 | 2716 | |
| 8 | 1964 | 7.9% |
| 2 | 1835 | 7.4% |
| 5 | 1659 | 6.7% |
| 7 | 1425 | 5.7% |
| 4 | 1260 | 5.1% |
| 3 | 1216 | 4.9% |
| I | 1077 | 4.3% |
| Other values (22) | 5604 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 19192 | |
| Uppercase Letter | 5746 | 23.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1077 | |
| R | 978 | |
| Z | 903 | |
| E | 693 | |
| M | 440 | |
| K | 332 | 5.8% |
| N | 250 | 4.4% |
| J | 203 | 3.5% |
| D | 140 | 2.4% |
| G | 138 | 2.4% |
| Other values (12) | 592 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3202 | |
| 0 | 2980 | |
| 9 | 2716 | |
| 8 | 1964 | |
| 2 | 1835 | |
| 5 | 1659 | |
| 7 | 1425 | |
| 4 | 1260 | 6.6% |
| 3 | 1216 | 6.3% |
| 6 | 935 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19192 | |
| Latin | 5746 | 23.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 1077 | |
| R | 978 | |
| Z | 903 | |
| E | 693 | |
| M | 440 | |
| K | 332 | 5.8% |
| N | 250 | 4.4% |
| J | 203 | 3.5% |
| D | 140 | 2.4% |
| G | 138 | 2.4% |
| Other values (12) | 592 |
Common
| Value | Count | Frequency (%) |
| 1 | 3202 | |
| 0 | 2980 | |
| 9 | 2716 | |
| 8 | 1964 | |
| 2 | 1835 | |
| 5 | 1659 | |
| 7 | 1425 | |
| 4 | 1260 | 6.6% |
| 3 | 1216 | 6.3% |
| 6 | 935 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24938 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 3202 | |
| 0 | 2980 | |
| 9 | 2716 | |
| 8 | 1964 | 7.9% |
| 2 | 1835 | 7.4% |
| 5 | 1659 | 6.7% |
| 7 | 1425 | 5.7% |
| 4 | 1260 | 5.1% |
| 3 | 1216 | 4.9% |
| I | 1077 | 4.3% |
| Other values (22) | 5604 |
PRESENT_ON_ADMIT
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 0 | |
|---|---|
| N | |
| Y |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5571 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Y |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2341 | |
| N | 1765 | |
| Y | 1465 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 2341 | |
| n | 1765 | |
| y | 1465 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2341 | |
| N | 1765 | |
| Y | 1465 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3230 | |
| Decimal Number | 2341 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 1765 | |
| Y | 1465 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3230 | |
| Common | 2341 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 1765 | |
| Y | 1465 |
Common
| Value | Count | Frequency (%) |
| 0 | 2341 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2341 | |
| N | 1765 | |
| Y | 1465 |
DUAL_STATUS
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 5 | |
|---|---|
| 3 | |
| 1 | |
| 8 | |
| 0 | |
| Other values (5) |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.0107701 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5631 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5 |
|---|---|
| 2nd row | 0 |
| 3rd row | 4 |
| 4th row | 2 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 | |
| Yes | 30 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 | |
| yes | 30 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 | |
| Y | 30 | 0.5% |
| Other values (2) | 60 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5541 | |
| Lowercase Letter | 60 | 1.1% |
| Uppercase Letter | 30 | 0.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 30 | |
| s | 30 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 30 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5541 | |
| Latin | 90 | 1.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 |
Latin
| Value | Count | Frequency (%) |
| Y | 30 | |
| e | 30 | |
| s | 30 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5631 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 773 | |
| 3 | 722 | |
| 1 | 635 | |
| 8 | 630 | |
| 0 | 607 | |
| 6 | 594 | |
| 7 | 583 | |
| 2 | 546 | |
| 4 | 451 | |
| Y | 30 | 0.5% |
| Other values (2) | 60 | 1.1% |
ENCOUNTER_TYPE
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| Outpatient | |
|---|---|
| Other | |
| Emergency Department | |
| Skilled Nursing Facility | |
| Acute Inpatient |
Length
| Max length | 24 |
|---|---|
| Median length | 15 |
| Mean length | 14.084365 |
| Min length | 5 |
Characters and Unicode
| Total characters | 78464 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Acute Inpatient |
|---|---|
| 2nd row | Other |
| 3rd row | Emergency Department |
| 4th row | Other |
| 5th row | Other |
Common Values
| Value | Count | Frequency (%) |
| Outpatient | 1452 | |
| Other | 1178 | |
| Emergency Department | 1166 | |
| Skilled Nursing Facility | 901 | |
| Acute Inpatient | 874 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| outpatient | 1452 | |
| other | 1178 | |
| emergency | 1166 | |
| department | 1166 | |
| skilled | 901 | |
| nursing | 901 | |
| facility | 901 | |
| acute | 874 | |
| inpatient | 874 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 11389 | |
| e | 9943 | |
| n | 6433 | 8.2% |
| i | 5930 | 7.6% |
| r | 4411 | 5.6% |
| a | 4393 | 5.6% |
| 3842 | 4.9% | |
| p | 3492 | 4.5% |
| u | 3227 | 4.1% |
| c | 2941 | 3.7% |
| Other values (16) | 22463 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 65209 | |
| Uppercase Letter | 9413 | 12.0% |
| Space Separator | 3842 | 4.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 11389 | |
| e | 9943 | |
| n | 6433 | |
| i | 5930 | |
| r | 4411 | 6.8% |
| a | 4393 | 6.7% |
| p | 3492 | 5.4% |
| u | 3227 | 4.9% |
| c | 2941 | 4.5% |
| l | 2703 | 4.1% |
| Other values (7) | 10347 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 2630 | |
| E | 1166 | |
| D | 1166 | |
| S | 901 | 9.6% |
| N | 901 | 9.6% |
| F | 901 | 9.6% |
| A | 874 | 9.3% |
| I | 874 | 9.3% |
Space Separator
| Value | Count | Frequency (%) |
| 3842 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 74622 | |
| Common | 3842 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 11389 | |
| e | 9943 | |
| n | 6433 | 8.6% |
| i | 5930 | 7.9% |
| r | 4411 | 5.9% |
| a | 4393 | 5.9% |
| p | 3492 | 4.7% |
| u | 3227 | 4.3% |
| c | 2941 | 3.9% |
| l | 2703 | 3.6% |
| Other values (15) | 19760 |
Common
| Value | Count | Frequency (%) |
| 3842 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 78464 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 11389 | |
| e | 9943 | |
| n | 6433 | 8.2% |
| i | 5930 | 7.6% |
| r | 4411 | 5.6% |
| a | 4393 | 5.6% |
| 3842 | 4.9% | |
| p | 3492 | 4.5% |
| u | 3227 | 4.1% |
| c | 2941 | 3.7% |
| Other values (16) | 22463 |
CLAIM_STATUS
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| Approved | |
|---|---|
| Denied |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.3218453 |
| Min length | 6 |
Characters and Unicode
| Total characters | 40790 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Denied |
|---|---|
| 2nd row | Denied |
| 3rd row | Denied |
| 4th row | Denied |
| 5th row | Denied |
Common Values
| Value | Count | Frequency (%) |
| Approved | 3682 | |
| Denied | 1889 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| approved | 3682 | |
| denied | 1889 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7460 | |
| p | 7364 | |
| d | 5571 | |
| A | 3682 | |
| r | 3682 | |
| o | 3682 | |
| v | 3682 | |
| D | 1889 | 4.6% |
| n | 1889 | 4.6% |
| i | 1889 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35219 | |
| Uppercase Letter | 5571 | 13.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 7460 | |
| p | 7364 | |
| d | 5571 | |
| r | 3682 | |
| o | 3682 | |
| v | 3682 | |
| n | 1889 | 5.4% |
| i | 1889 | 5.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 3682 | |
| D | 1889 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 40790 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 7460 | |
| p | 7364 | |
| d | 5571 | |
| A | 3682 | |
| r | 3682 | |
| o | 3682 | |
| v | 3682 | |
| D | 1889 | 4.6% |
| n | 1889 | 4.6% |
| i | 1889 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 40790 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 7460 | |
| p | 7364 | |
| d | 5571 | |
| A | 3682 | |
| r | 3682 | |
| o | 3682 | |
| v | 3682 | |
| D | 1889 | 4.6% |
| n | 1889 | 4.6% |
| i | 1889 | 4.6% |
PAYERS
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| BCBS | |
|---|---|
| Medicare | |
| Aetna | |
| Cigna | |
| Humana |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.4491115 |
| Min length | 3 |
Characters and Unicode
| Total characters | 30357 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Medicare |
|---|---|
| 2nd row | Medicare |
| 3rd row | Humana |
| 4th row | Medicare |
| 5th row | Cigna |
Common Values
| Value | Count | Frequency (%) |
| BCBS | 1680 | |
| Medicare | 1394 | |
| Aetna | 951 | |
| Cigna | 718 | |
| Humana | 552 | 9.9% |
| UHG | 276 | 5.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bcbs | 1680 | |
| medicare | 1394 | |
| aetna | 951 | |
| cigna | 718 | |
| humana | 552 | 9.9% |
| uhg | 276 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4167 | |
| e | 3739 | |
| B | 3360 | |
| C | 2398 | 7.9% |
| n | 2221 | 7.3% |
| i | 2112 | 7.0% |
| S | 1680 | 5.5% |
| r | 1394 | 4.6% |
| c | 1394 | 4.6% |
| d | 1394 | 4.6% |
| Other values (9) | 6498 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 19194 | |
| Uppercase Letter | 11163 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4167 | |
| e | 3739 | |
| n | 2221 | |
| i | 2112 | |
| r | 1394 | 7.3% |
| c | 1394 | 7.3% |
| d | 1394 | 7.3% |
| t | 951 | 5.0% |
| g | 718 | 3.7% |
| u | 552 | 2.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 3360 | |
| C | 2398 | |
| S | 1680 | |
| M | 1394 | |
| A | 951 | 8.5% |
| H | 828 | 7.4% |
| U | 276 | 2.5% |
| G | 276 | 2.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30357 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4167 | |
| e | 3739 | |
| B | 3360 | |
| C | 2398 | 7.9% |
| n | 2221 | 7.3% |
| i | 2112 | 7.0% |
| S | 1680 | 5.5% |
| r | 1394 | 4.6% |
| c | 1394 | 4.6% |
| d | 1394 | 4.6% |
| Other values (9) | 6498 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30357 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4167 | |
| e | 3739 | |
| B | 3360 | |
| C | 2398 | 7.9% |
| n | 2221 | 7.3% |
| i | 2112 | 7.0% |
| S | 1680 | 5.5% |
| r | 1394 | 4.6% |
| c | 1394 | 4.6% |
| d | 1394 | 4.6% |
| Other values (9) | 6498 |
DENIAL_CATEGORY
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| NOT_APPLICABLE | |
|---|---|
| Prior Authorization | |
| Eligibility | |
| Coding Error | 207 |
| Benefit Exhausted | 63 |
Length
| Max length | 19 |
|---|---|
| Median length | 14 |
| Mean length | 14.750494 |
| Min length | 6 |
Characters and Unicode
| Total characters | 82175 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Eligibility |
|---|---|
| 2nd row | Coding Error |
| 3rd row | Prior Authorization |
| 4th row | Benefit Exhausted |
| 5th row | Coding Error |
Common Values
| Value | Count | Frequency (%) |
| NOT_APPLICABLE | 3682 | |
| Prior Authorization | 1176 | 21.1% |
| Eligibility | 414 | 7.4% |
| Coding Error | 207 | 3.7% |
| Benefit Exhausted | 63 | 1.1% |
| Others | 29 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| not_applicable | 3682 | |
| prior | 1176 | 16.8% |
| authorization | 1176 | 16.8% |
| eligibility | 414 | 5.9% |
| coding | 207 | 2.9% |
| error | 207 | 2.9% |
| benefit | 63 | 0.9% |
| exhausted | 63 | 0.9% |
| others | 29 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 8540 | 10.4% |
| P | 8540 | 10.4% |
| L | 7364 | 9.0% |
| i | 5454 | 6.6% |
| E | 4366 | 5.3% |
| r | 4178 | 5.1% |
| o | 3942 | 4.8% |
| C | 3889 | 4.7% |
| B | 3745 | 4.6% |
| O | 3711 | 4.5% |
| Other values (20) | 28446 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 51201 | |
| Lowercase Letter | 25846 | |
| Connector Punctuation | 3682 | 4.5% |
| Space Separator | 1446 | 1.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 5454 | |
| r | 4178 | |
| o | 3942 | |
| t | 2921 | |
| n | 1446 | 5.6% |
| h | 1268 | 4.9% |
| a | 1239 | 4.8% |
| u | 1239 | 4.8% |
| z | 1176 | 4.6% |
| l | 828 | 3.2% |
| Other values (8) | 2155 | 8.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 8540 | |
| P | 8540 | |
| L | 7364 | |
| E | 4366 | |
| C | 3889 | |
| B | 3745 | |
| O | 3711 | |
| N | 3682 | |
| I | 3682 | |
| T | 3682 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3682 |
Space Separator
| Value | Count | Frequency (%) |
| 1446 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 77047 | |
| Common | 5128 | 6.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 8540 | 11.1% |
| P | 8540 | 11.1% |
| L | 7364 | 9.6% |
| i | 5454 | 7.1% |
| E | 4366 | 5.7% |
| r | 4178 | 5.4% |
| o | 3942 | 5.1% |
| C | 3889 | 5.0% |
| B | 3745 | 4.9% |
| O | 3711 | 4.8% |
| Other values (18) | 23318 |
Common
| Value | Count | Frequency (%) |
| _ | 3682 | |
| 1446 | 28.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 82175 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 8540 | 10.4% |
| P | 8540 | 10.4% |
| L | 7364 | 9.0% |
| i | 5454 | 6.6% |
| E | 4366 | 5.3% |
| r | 4178 | 5.1% |
| o | 3942 | 4.8% |
| C | 3889 | 4.7% |
| B | 3745 | 4.6% |
| O | 3711 | 4.5% |
| Other values (20) | 28446 |
PROCEDURE_CODE
Categorical
| Distinct | 135 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 03CL0ZZ | 200 |
|---|---|
| 0T768DZ | 185 |
| 5A1945Z | 179 |
| 0D9670Z | 178 |
| 03CK0ZZ | 171 |
| Other values (130) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 38997 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 0RGA071 |
|---|---|
| 2nd row | 0W3P8ZZ |
| 3rd row | 0D9670Z |
| 4th row | 4A023N7 |
| 5th row | 06BQ4ZZ |
Common Values
| Value | Count | Frequency (%) |
| 03CL0ZZ | 200 | 3.6% |
| 0T768DZ | 185 | 3.3% |
| 5A1945Z | 179 | 3.2% |
| 0D9670Z | 178 | 3.2% |
| 03CK0ZZ | 171 | 3.1% |
| 027034Z | 143 | 2.6% |
| B548ZZA | 135 | 2.4% |
| 8E0W4CZ | 135 | 2.4% |
| 0SPC08Z | 130 | 2.3% |
| 0SB20ZZ | 126 | 2.3% |
| Other values (125) | 3989 |
Length
| Value | Count | Frequency (%) |
| 03cl0zz | 200 | 3.6% |
| 0t768dz | 185 | 3.3% |
| 5a1945z | 179 | 3.2% |
| 0d9670z | 178 | 3.2% |
| 03ck0zz | 171 | 3.1% |
| 027034z | 143 | 2.6% |
| b548zza | 135 | 2.4% |
| 8e0w4cz | 135 | 2.4% |
| 0spc08z | 130 | 2.3% |
| 0sb20zz | 126 | 2.3% |
| Other values (125) | 3989 |
Most occurring characters
| Value | Count | Frequency (%) |
| Z | 6989 | |
| 0 | 6504 | |
| 3 | 2972 | 7.6% |
| 4 | 2068 | 5.3% |
| B | 1882 | 4.8% |
| 2 | 1804 | 4.6% |
| 1 | 1664 | 4.3% |
| 8 | 1629 | 4.2% |
| 5 | 1457 | 3.7% |
| A | 1424 | 3.7% |
| Other values (24) | 10604 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 20930 | |
| Uppercase Letter | 18067 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Z | 6989 | |
| B | 1882 | 10.4% |
| A | 1424 | 7.9% |
| D | 1089 | 6.0% |
| C | 860 | 4.8% |
| S | 687 | 3.8% |
| X | 574 | 3.2% |
| E | 512 | 2.8% |
| P | 477 | 2.6% |
| T | 457 | 2.5% |
| Other values (14) | 3116 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 6504 | |
| 3 | 2972 | |
| 4 | 2068 | 9.9% |
| 2 | 1804 | 8.6% |
| 1 | 1664 | 8.0% |
| 8 | 1629 | 7.8% |
| 5 | 1457 | 7.0% |
| 7 | 1262 | 6.0% |
| 9 | 820 | 3.9% |
| 6 | 750 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 20930 | |
| Latin | 18067 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Z | 6989 | |
| B | 1882 | 10.4% |
| A | 1424 | 7.9% |
| D | 1089 | 6.0% |
| C | 860 | 4.8% |
| S | 687 | 3.8% |
| X | 574 | 3.2% |
| E | 512 | 2.8% |
| P | 477 | 2.6% |
| T | 457 | 2.5% |
| Other values (14) | 3116 |
Common
| Value | Count | Frequency (%) |
| 0 | 6504 | |
| 3 | 2972 | |
| 4 | 2068 | 9.9% |
| 2 | 1804 | 8.6% |
| 1 | 1664 | 8.0% |
| 8 | 1629 | 7.8% |
| 5 | 1457 | 7.0% |
| 7 | 1262 | 6.0% |
| 9 | 820 | 3.9% |
| 6 | 750 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38997 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Z | 6989 | |
| 0 | 6504 | |
| 3 | 2972 | 7.6% |
| 4 | 2068 | 5.3% |
| B | 1882 | 4.8% |
| 2 | 1804 | 4.6% |
| 1 | 1664 | 4.3% |
| 8 | 1629 | 4.2% |
| 5 | 1457 | 3.7% |
| A | 1424 | 3.7% |
| Other values (24) | 10604 |
PROCEDURE_DESCRIPTION
Categorical
| Distinct | 122 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| Precertification/authorization/notification/pre-treatment absent. | 320 |
|---|---|
| Plan procedures not followed. | 314 |
| Patient refused the service/procedure. | 311 |
| Dilation of Right Ureter with Intraluminal Device, Endo | 159 |
| Extirpation of Matter from L Int Carotid, Open Approach | 152 |
| Other values (117) |
Length
| Max length | 116 |
|---|---|
| Median length | 68 |
| Mean length | 51.65105 |
| Min length | 27 |
Characters and Unicode
| Total characters | 287748 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Charges do not meet qualifications for emergent/urgent care. |
|---|---|
| 2nd row | Processed in Excess of charges. |
| 3rd row | Lifetime benefit maximum has been reached for this service/benefit category. |
| 4th row | ESRD network support adjustment. |
| 5th row | The procedure code is inconsistent with the provider type/specialty (taxonomy). |
Common Values
| Value | Count | Frequency (%) |
| Precertification/authorization/notification/pre-treatment absent. | 320 | 5.7% |
| Plan procedures not followed. | 314 | 5.6% |
| Patient refused the service/procedure. | 311 | 5.6% |
| Dilation of Right Ureter with Intraluminal Device, Endo | 159 | 2.9% |
| Extirpation of Matter from L Int Carotid, Open Approach | 152 | 2.7% |
| Respiratory Ventilation, 24-96 Consecutive Hours | 125 | 2.2% |
| Dilation of 1 Cor Art with Drug-elut Intra, Perc Approach | 123 | 2.2% |
| Drainage of Stomach with Drainage Device, Via Opening | 117 | 2.1% |
| Extirpation of Matter from R Int Carotid, Open Approach | 108 | 1.9% |
| Measure Cardiac Sampl & Pressure, Bilateral, Perc | 96 | 1.7% |
| Other values (112) | 3746 |
Length
| Value | Count | Frequency (%) |
| of | 2995 | 7.6% |
| approach | 1603 | 4.1% |
| the | 1139 | 2.9% |
| with | 1061 | 2.7% |
| open | 948 | 2.4% |
| perc | 883 | 2.2% |
| endo | 836 | 2.1% |
| excision | 513 | 1.3% |
| not | 487 | 1.2% |
| dilation | 407 | 1.0% |
| Other values (327) | 28594 |
Most occurring characters
| Value | Count | Frequency (%) |
| 33984 | 11.8% | |
| e | 25696 | 8.9% |
| o | 20938 | 7.3% |
| r | 20155 | 7.0% |
| t | 19985 | 6.9% |
| i | 18332 | 6.4% |
| n | 17708 | 6.2% |
| a | 16792 | 5.8% |
| s | 11018 | 3.8% |
| c | 10791 | 3.8% |
| Other values (53) | 92349 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 218593 | |
| Space Separator | 33984 | 11.8% |
| Uppercase Letter | 25059 | 8.7% |
| Other Punctuation | 8074 | 2.8% |
| Decimal Number | 1044 | 0.4% |
| Dash Punctuation | 859 | 0.3% |
| Open Punctuation | 60 | < 0.1% |
| Close Punctuation | 60 | < 0.1% |
| Math Symbol | 15 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 25696 | |
| o | 20938 | |
| r | 20155 | |
| t | 19985 | |
| i | 18332 | 8.4% |
| n | 17708 | 8.1% |
| a | 16792 | 7.7% |
| s | 11018 | 5.0% |
| c | 10791 | 4.9% |
| p | 9544 | 4.4% |
| Other values (16) | 47634 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 3073 | |
| A | 2773 | |
| C | 2226 | 8.9% |
| E | 2128 | 8.5% |
| D | 1783 | 7.1% |
| O | 1520 | 6.1% |
| R | 1520 | 6.1% |
| I | 1433 | 5.7% |
| V | 1266 | 5.1% |
| T | 1119 | 4.5% |
| Other values (12) | 6218 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 4217 | |
| . | 1802 | |
| / | 1707 | |
| ' | 208 | 2.6% |
| & | 140 | 1.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 301 | |
| 9 | 238 | |
| 2 | 221 | |
| 4 | 161 | |
| 1 | 123 |
Space Separator
| Value | Count | Frequency (%) |
| 33984 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 859 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 60 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 60 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 15 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 243652 | |
| Common | 44096 | 15.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 25696 | 10.5% |
| o | 20938 | 8.6% |
| r | 20155 | 8.3% |
| t | 19985 | 8.2% |
| i | 18332 | 7.5% |
| n | 17708 | 7.3% |
| a | 16792 | 6.9% |
| s | 11018 | 4.5% |
| c | 10791 | 4.4% |
| p | 9544 | 3.9% |
| Other values (38) | 72693 |
Common
| Value | Count | Frequency (%) |
| 33984 | ||
| , | 4217 | 9.6% |
| . | 1802 | 4.1% |
| / | 1707 | 3.9% |
| - | 859 | 1.9% |
| 6 | 301 | 0.7% |
| 9 | 238 | 0.5% |
| 2 | 221 | 0.5% |
| ' | 208 | 0.5% |
| 4 | 161 | 0.4% |
| Other values (5) | 398 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 287748 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 33984 | 11.8% | |
| e | 25696 | 8.9% |
| o | 20938 | 7.3% |
| r | 20155 | 7.0% |
| t | 19985 | 6.9% |
| i | 18332 | 6.4% |
| n | 17708 | 6.2% |
| a | 16792 | 5.8% |
| s | 11018 | 3.8% |
| c | 10791 | 3.8% |
| Other values (53) | 92349 |
PLACE_OF_SERVICE_CODE
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 23 | |
|---|---|
| 22 | |
| 99 | |
| 11 | |
| 21 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 11142 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 21 |
|---|---|
| 2nd row | 23 |
| 3rd row | 23 |
| 4th row | 99 |
| 5th row | 99 |
Common Values
| Value | Count | Frequency (%) |
| 23 | 2750 | |
| 22 | 904 | 16.2% |
| 99 | 766 | 13.7% |
| 11 | 669 | 12.0% |
| 21 | 482 | 8.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 23 | 2750 | |
| 22 | 904 | 16.2% |
| 99 | 766 | 13.7% |
| 11 | 669 | 12.0% |
| 21 | 482 | 8.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5040 | |
| 3 | 2750 | |
| 1 | 1820 | 16.3% |
| 9 | 1532 | 13.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11142 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 5040 | |
| 3 | 2750 | |
| 1 | 1820 | 16.3% |
| 9 | 1532 | 13.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 11142 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 5040 | |
| 3 | 2750 | |
| 1 | 1820 | 16.3% |
| 9 | 1532 | 13.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11142 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 5040 | |
| 3 | 2750 | |
| 1 | 1820 | 16.3% |
| 9 | 1532 | 13.7% |
REVENUE_CENTER_CODE
Real number (ℝ)
| Distinct | 100 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 405.32382 |
| Minimum | 23 |
|---|---|
| Maximum | 983 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 23 |
|---|---|
| 5-th percentile | 258 |
| Q1 | 300 |
| median | 307 |
| Q3 | 460 |
| 95-th percentile | 730 |
| Maximum | 983 |
| Range | 960 |
| Interquartile range (IQR) | 160 |
Descriptive statistics
| Standard deviation | 162.27526 |
|---|---|
| Coefficient of variation (CV) | 0.40035954 |
| Kurtosis | 1.6162923 |
| Mean | 405.32382 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | 1.4961746 |
| Sum | 2258059 |
| Variance | 26333.259 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300 | 990 | |
| 301 | 810 | |
| 636 | 354 | 6.4% |
| 305 | 265 | 4.8% |
| 420 | 251 | 4.5% |
| 510 | 234 | 4.2% |
| 450 | 232 | 4.2% |
| 250 | 198 | 3.6% |
| 730 | 153 | 2.7% |
| 320 | 116 | 2.1% |
| Other values (90) | 1968 |
| Value | Count | Frequency (%) |
| 23 | 3 | 0.1% |
| 200 | 8 | 0.1% |
| 214 | 1 | < 0.1% |
| 250 | 198 | |
| 251 | 10 | 0.2% |
| 255 | 5 | 0.1% |
| 258 | 57 | 1.0% |
| 259 | 3 | 0.1% |
| 260 | 64 | 1.1% |
| 270 | 54 | 1.0% |
| Value | Count | Frequency (%) |
| 983 | 1 | < 0.1% |
| 982 | 1 | < 0.1% |
| 981 | 6 | 0.1% |
| 975 | 1 | < 0.1% |
| 972 | 3 | 0.1% |
| 964 | 1 | < 0.1% |
| 960 | 1 | < 0.1% |
| 943 | 58 | |
| 942 | 2 | < 0.1% |
| 940 | 15 | 0.3% |
DISCHARGE_DISPOSITION_CODE
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4281099 |
| Minimum | 0 |
|---|---|
| Maximum | 70 |
| Zeros | 20 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 6 |
| Maximum | 70 |
| Range | 70 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.4463531 |
|---|---|
| Coefficient of variation (CV) | 2.6548853 |
| Kurtosis | 46.729085 |
| Mean | 2.4281099 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.4264785 |
| Sum | 13527 |
| Variance | 41.555468 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4838 | |
| 6 | 289 | 5.2% |
| 30 | 133 | 2.4% |
| 3 | 113 | 2.0% |
| 2 | 64 | 1.1% |
| 4 | 46 | 0.8% |
| 62 | 28 | 0.5% |
| 7 | 26 | 0.5% |
| 0 | 20 | 0.4% |
| 9 | 8 | 0.1% |
| Other values (3) | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 20 | 0.4% |
| 1 | 4838 | |
| 2 | 64 | 1.1% |
| 3 | 113 | 2.0% |
| 4 | 46 | 0.8% |
| 6 | 289 | 5.2% |
| 7 | 26 | 0.5% |
| 9 | 8 | 0.1% |
| 30 | 133 | 2.4% |
| 50 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 70 | 1 | < 0.1% |
| 62 | 28 | 0.5% |
| 51 | 4 | 0.1% |
| 50 | 1 | < 0.1% |
| 30 | 133 | |
| 9 | 8 | 0.1% |
| 7 | 26 | 0.5% |
| 6 | 289 | |
| 4 | 46 | 0.8% |
| 3 | 113 | 2.0% |
MEDICARE_STATUS
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 10 | |
|---|---|
| 20 | |
| 0 | 169 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.9696643 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10973 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 20 |
|---|---|
| 2nd row | 10 |
| 3rd row | 10 |
| 4th row | 10 |
| 5th row | 20 |
Common Values
| Value | Count | Frequency (%) |
| 10 | 4327 | |
| 20 | 1075 | 19.3% |
| 0 | 169 | 3.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 10 | 4327 | |
| 20 | 1075 | 19.3% |
| 0 | 169 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5571 | |
| 1 | 4327 | |
| 2 | 1075 | 9.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10973 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5571 | |
| 1 | 4327 | |
| 2 | 1075 | 9.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10973 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5571 | |
| 1 | 4327 | |
| 2 | 1075 | 9.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10973 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5571 | |
| 1 | 4327 | |
| 2 | 1075 | 9.8% |
ADMIT_SOURCE_CODE
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 2 | |
|---|---|
| 4 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5571 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 2 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5571 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5571 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 1980 | |
| 4 | 1805 | |
| 1 | 1786 |
ADMIT_TYPE_CODE
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 87.0 KiB |
| 1 | |
|---|---|
| 3 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5571 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5571 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5571 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2127 | |
| 3 | 1735 | |
| 2 | 1709 |
MS_DRG
Real number (ℝ)
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 372.53294 |
| Minimum | 42 |
|---|---|
| Maximum | 920 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 87.0 KiB |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 149 |
| Q1 | 247 |
| median | 309 |
| Q3 | 442 |
| 95-th percentile | 872 |
| Maximum | 920 |
| Range | 878 |
| Interquartile range (IQR) | 195 |
Descriptive statistics
| Standard deviation | 206.44995 |
|---|---|
| Coefficient of variation (CV) | 0.55417906 |
| Kurtosis | 0.84743287 |
| Mean | 372.53294 |
| Median Absolute Deviation (MAD) | 104 |
| Skewness | 1.1810481 |
| Sum | 2075381 |
| Variance | 42621.584 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 442 | 375 | 6.7% |
| 205 | 271 | 4.9% |
| 292 | 267 | 4.8% |
| 176 | 243 | 4.4% |
| 233 | 227 | 4.1% |
| 309 | 226 | 4.1% |
| 202 | 216 | 3.9% |
| 291 | 210 | 3.8% |
| 683 | 206 | 3.7% |
| 149 | 206 | 3.7% |
| Other values (23) | 3124 |
| Value | Count | Frequency (%) |
| 42 | 120 | |
| 69 | 105 | 1.9% |
| 149 | 206 | |
| 176 | 243 | |
| 202 | 216 | |
| 205 | 271 | |
| 233 | 227 | |
| 247 | 110 | |
| 264 | 37 | 0.7% |
| 280 | 140 |
| Value | Count | Frequency (%) |
| 920 | 147 | 2.6% |
| 872 | 138 | 2.5% |
| 871 | 157 | |
| 690 | 73 | 1.3% |
| 683 | 206 | |
| 641 | 135 | 2.4% |
| 603 | 85 | 1.5% |
| 481 | 112 | 2.0% |
| 470 | 157 | |
| 442 | 375 |
| APPROVED_CHARGE | REASON_CODE | Age | SERVICE_UNIT_QUANTITY | TOTAL_CHARGES | REVENUE_CENTER_CODE | DISCHARGE_DISPOSITION_CODE | MS_DRG | BILL_TYPE_CODE | GENDER | RACE | STATE | PRESENT_ON_ADMIT | DUAL_STATUS | ENCOUNTER_TYPE | CLAIM_STATUS | PAYERS | DENIAL_CATEGORY | PLACE_OF_SERVICE_CODE | MEDICARE_STATUS | ADMIT_SOURCE_CODE | ADMIT_TYPE_CODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| APPROVED_CHARGE | 1.000 | -0.301 | 0.056 | 0.416 | 0.935 | 0.142 | 0.374 | 0.048 | 0.315 | 0.165 | 0.134 | 0.279 | 0.145 | 0.134 | 0.123 | 0.211 | 0.000 | 0.092 | 0.154 | 0.111 | 0.124 | 0.124 |
| REASON_CODE | -0.301 | 1.000 | -0.009 | -0.158 | -0.085 | 0.104 | -0.127 | -0.017 | 0.081 | 0.000 | 0.000 | 0.055 | 0.046 | 0.141 | 0.017 | 0.894 | 0.000 | 0.502 | 0.026 | 0.012 | 0.013 | 0.032 |
| Age | 0.056 | -0.009 | 1.000 | 0.035 | 0.071 | 0.013 | 0.099 | -0.057 | 0.158 | 0.171 | 0.138 | 0.369 | 0.161 | 0.185 | 0.174 | 0.107 | 0.000 | 0.120 | 0.167 | 0.703 | 0.182 | 0.189 |
| SERVICE_UNIT_QUANTITY | 0.416 | -0.158 | 0.035 | 1.000 | 0.401 | 0.024 | 0.226 | 0.044 | 0.038 | 0.000 | 0.050 | 0.000 | 0.044 | 0.000 | 0.014 | 0.004 | 0.000 | 0.000 | 0.028 | 0.017 | 0.018 | 0.000 |
| TOTAL_CHARGES | 0.935 | -0.085 | 0.071 | 0.401 | 1.000 | 0.145 | 0.365 | 0.059 | 0.317 | 0.167 | 0.135 | 0.281 | 0.145 | 0.136 | 0.123 | 0.208 | 0.000 | 0.091 | 0.151 | 0.113 | 0.129 | 0.128 |
| REVENUE_CENTER_CODE | 0.142 | 0.104 | 0.013 | 0.024 | 0.145 | 1.000 | 0.030 | 0.032 | 0.246 | 0.063 | 0.052 | 0.123 | 0.056 | 0.067 | 0.058 | 0.234 | 0.020 | 0.113 | 0.059 | 0.066 | 0.051 | 0.086 |
| DISCHARGE_DISPOSITION_CODE | 0.374 | -0.127 | 0.099 | 0.226 | 0.365 | 0.030 | 1.000 | 0.132 | 0.424 | 0.155 | 0.174 | 0.233 | 0.051 | 0.096 | 0.070 | 0.050 | 0.034 | 0.017 | 0.036 | 0.038 | 0.093 | 0.086 |
| MS_DRG | 0.048 | -0.017 | -0.057 | 0.044 | 0.059 | 0.032 | 0.132 | 1.000 | 0.185 | 0.189 | 0.126 | 0.388 | 0.181 | 0.164 | 0.159 | 0.063 | 0.012 | 0.031 | 0.153 | 0.155 | 0.143 | 0.168 |
| BILL_TYPE_CODE | 0.315 | 0.081 | 0.158 | 0.038 | 0.317 | 0.246 | 0.424 | 0.185 | 1.000 | 0.146 | 0.248 | 0.270 | 0.184 | 0.190 | 0.222 | 0.188 | 0.029 | 0.079 | 0.206 | 0.139 | 0.185 | 0.174 |
| GENDER | 0.165 | 0.000 | 0.171 | 0.000 | 0.167 | 0.063 | 0.155 | 0.189 | 0.146 | 1.000 | 0.145 | 0.406 | 0.073 | 0.218 | 0.215 | 0.000 | 0.017 | 0.000 | 0.158 | 0.084 | 0.092 | 0.178 |
| RACE | 0.134 | 0.000 | 0.138 | 0.050 | 0.135 | 0.052 | 0.174 | 0.126 | 0.248 | 0.145 | 1.000 | 0.331 | 0.117 | 0.150 | 0.150 | 0.000 | 0.026 | 0.000 | 0.134 | 0.166 | 0.074 | 0.169 |
| STATE | 0.279 | 0.055 | 0.369 | 0.000 | 0.281 | 0.123 | 0.233 | 0.388 | 0.270 | 0.406 | 0.331 | 1.000 | 0.414 | 0.382 | 0.361 | 0.146 | 0.071 | 0.065 | 0.368 | 0.360 | 0.440 | 0.399 |
| PRESENT_ON_ADMIT | 0.145 | 0.046 | 0.161 | 0.044 | 0.145 | 0.056 | 0.051 | 0.181 | 0.184 | 0.073 | 0.117 | 0.414 | 1.000 | 0.218 | 0.153 | 0.072 | 0.000 | 0.049 | 0.129 | 0.113 | 0.144 | 0.107 |
| DUAL_STATUS | 0.134 | 0.141 | 0.185 | 0.000 | 0.136 | 0.067 | 0.096 | 0.164 | 0.190 | 0.218 | 0.150 | 0.382 | 0.218 | 1.000 | 0.202 | 0.127 | 0.017 | 0.121 | 0.199 | 0.188 | 0.181 | 0.200 |
| ENCOUNTER_TYPE | 0.123 | 0.017 | 0.174 | 0.014 | 0.123 | 0.058 | 0.070 | 0.159 | 0.222 | 0.215 | 0.150 | 0.361 | 0.153 | 0.202 | 1.000 | 0.066 | 0.018 | 0.033 | 0.742 | 0.114 | 0.131 | 0.159 |
| CLAIM_STATUS | 0.211 | 0.894 | 0.107 | 0.004 | 0.208 | 0.234 | 0.050 | 0.063 | 0.188 | 0.000 | 0.000 | 0.146 | 0.072 | 0.127 | 0.066 | 1.000 | 0.000 | 1.000 | 0.075 | 0.023 | 0.000 | 0.031 |
| PAYERS | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.020 | 0.034 | 0.012 | 0.029 | 0.017 | 0.026 | 0.071 | 0.000 | 0.017 | 0.018 | 0.000 | 1.000 | 0.000 | 0.009 | 0.000 | 0.000 | 0.015 |
| DENIAL_CATEGORY | 0.092 | 0.502 | 0.120 | 0.000 | 0.091 | 0.113 | 0.017 | 0.031 | 0.079 | 0.000 | 0.000 | 0.065 | 0.049 | 0.121 | 0.033 | 1.000 | 0.000 | 1.000 | 0.044 | 0.012 | 0.000 | 0.035 |
| PLACE_OF_SERVICE_CODE | 0.154 | 0.026 | 0.167 | 0.028 | 0.151 | 0.059 | 0.036 | 0.153 | 0.206 | 0.158 | 0.134 | 0.368 | 0.129 | 0.199 | 0.742 | 0.075 | 0.009 | 0.044 | 1.000 | 0.103 | 0.161 | 0.581 |
| MEDICARE_STATUS | 0.111 | 0.012 | 0.703 | 0.017 | 0.113 | 0.066 | 0.038 | 0.155 | 0.139 | 0.084 | 0.166 | 0.360 | 0.113 | 0.188 | 0.114 | 0.023 | 0.000 | 0.012 | 0.103 | 1.000 | 0.074 | 0.022 |
| ADMIT_SOURCE_CODE | 0.124 | 0.013 | 0.182 | 0.018 | 0.129 | 0.051 | 0.093 | 0.143 | 0.185 | 0.092 | 0.074 | 0.440 | 0.144 | 0.181 | 0.131 | 0.000 | 0.000 | 0.000 | 0.161 | 0.074 | 1.000 | 0.080 |
| ADMIT_TYPE_CODE | 0.124 | 0.032 | 0.189 | 0.000 | 0.128 | 0.086 | 0.086 | 0.168 | 0.174 | 0.178 | 0.169 | 0.399 | 0.107 | 0.200 | 0.159 | 0.031 | 0.015 | 0.035 | 0.581 | 0.022 | 0.080 | 1.000 |
| APPROVED_CHARGE | REASON_CODE | Age | SERVICE_UNIT_QUANTITY | TOTAL_CHARGES | BILL_TYPE_CODE | HCPCS_CODE | GENDER | RACE | STATE | COUNTY | CODE | PRESENT_ON_ADMIT | DUAL_STATUS | ENCOUNTER_TYPE | CLAIM_STATUS | PAYERS | DENIAL_CATEGORY | PROCEDURE_CODE | PROCEDURE_DESCRIPTION | PLACE_OF_SERVICE_CODE | REVENUE_CENTER_CODE | DISCHARGE_DISPOSITION_CODE | MEDICARE_STATUS | ADMIT_SOURCE_CODE | ADMIT_TYPE_CODE | MS_DRG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 44.62 | 22.0 | 38 | 1 | 225.62 | 131 | 82306 | male | white | North Carolina | Cherokee | G9340 | Y | 5 | Acute Inpatient | Denied | Medicare | Eligibility | 0RGA071 | Charges do not meet qualifications for emergent/urgent care. | 21 | 300 | 1 | 20 | 4 | 3 | 683 |
| 1 | 1457.06 | 27.0 | 84 | 10 | 1638.06 | 131 | J1644 | female | white | Utah | Summit | E1142 | 0 | 0 | Other | Denied | Medicare | Coding Error | 0W3P8ZZ | Processed in Excess of charges. | 23 | 636 | 1 | 10 | 2 | 1 | 470 |
| 2 | 254.95 | 74.0 | 81 | 1 | 326.95 | 131 | 76642 | female | white | Delaware | New Castle | I480 | 0 | 4 | Emergency Department | Denied | Humana | Prior Authorization | 0D9670Z | Lifetime benefit maximum has been reached for this service/benefit category. | 23 | 402 | 1 | 10 | 4 | 1 | 641 |
| 3 | 4.09 | 32.0 | 92 | 1 | 76.09 | 131 | 85610 | male | white | Connecticut | Fairfield | I10 | 0 | 2 | Other | Denied | Medicare | Benefit Exhausted | 4A023N7 | ESRD network support adjustment. | 99 | 300 | 1 | 10 | 4 | 3 | 378 |
| 4 | 56.11 | 8.0 | 69 | 1 | 173.11 | 131 | G0463 | male | white | Iowa | Pottawattamie | I255 | 0 | 7 | Other | Denied | Cigna | Coding Error | 06BQ4ZZ | The procedure code is inconsistent with the provider type/specialty (taxonomy). | 99 | 510 | 1 | 20 | 2 | 3 | 312 |
| 5 | 56.86 | 14.0 | 92 | 1 | 386.86 | 131 | 80053 | male | white | Connecticut | Fairfield | M1991 | 0 | 2 | Other | Denied | Humana | Eligibility | 4A023N7 | This care may be covered by another payer per coordination of benefits. | 99 | 301 | 1 | 10 | 4 | 3 | 378 |
| 6 | 157.42 | 18.0 | 92 | 1 | 250.42 | 131 | 71275 | male | white | Connecticut | Fairfield | D125 | 0 | 2 | Other | Denied | Cigna | Eligibility | 4A023N7 | Expenses incurred prior to coverage. | 99 | 352 | 1 | 10 | 4 | 3 | 378 |
| 7 | 33.76 | 111.0 | 69 | 1 | 97.76 | 131 | 94760 | male | white | Iowa | Pottawattamie | Z86010 | 0 | 7 | Other | Denied | Cigna | Eligibility | 06BQ4ZZ | Patient has not met the required eligibility requirements. | 99 | 460 | 1 | 20 | 2 | 3 | 312 |
| 8 | 115.73 | 22.0 | 80 | 1 | 232.73 | 131 | 82306 | male | white | California | Madera | I480 | 0 | 6 | Skilled Nursing Facility | Denied | Aetna | Eligibility | 0D9670Z | Charges do not meet qualifications for emergent/urgent care. | 11 | 301 | 1 | 10 | 4 | 2 | 683 |
| 9 | 32.48 | 116.0 | 83 | 1 | 125.48 | 131 | 36415 | female | white | Texas | Dallas | M069 | Y | 0 | Outpatient | Denied | Humana | Eligibility | 0SB20ZZ | Revenue code and Procedure code do not match. | 22 | 300 | 1 | 10 | 4 | 2 | 149 |
| APPROVED_CHARGE | REASON_CODE | Age | SERVICE_UNIT_QUANTITY | TOTAL_CHARGES | BILL_TYPE_CODE | HCPCS_CODE | GENDER | RACE | STATE | COUNTY | CODE | PRESENT_ON_ADMIT | DUAL_STATUS | ENCOUNTER_TYPE | CLAIM_STATUS | PAYERS | DENIAL_CATEGORY | PROCEDURE_CODE | PROCEDURE_DESCRIPTION | PLACE_OF_SERVICE_CODE | REVENUE_CENTER_CODE | DISCHARGE_DISPOSITION_CODE | MEDICARE_STATUS | ADMIT_SOURCE_CODE | ADMIT_TYPE_CODE | MS_DRG | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5590 | 10279.81 | 1.0 | 78 | 1 | 10279.81 | 111 | Q0511 | female | white | Pennsylvania | Delaware | Z1231 | 0 | 6 | Outpatient | Approved | Medicare | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 250 | 6 | 10 | 2 | 1 | 418 |
| 5591 | 11829.41 | 1.0 | 78 | 6 | 11829.41 | 111 | A4611 | female | white | Pennsylvania | Delaware | Z01810 | 0 | 6 | Outpatient | Approved | Cigna | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 270 | 6 | 10 | 2 | 1 | 418 |
| 5592 | 10714.01 | 1.0 | 78 | 4 | 10714.01 | 111 | A4206 | female | white | Pennsylvania | Delaware | I10 | 0 | 6 | Outpatient | Approved | Medicare | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 272 | 6 | 10 | 2 | 1 | 418 |
| 5593 | 5230.11 | 1.0 | 78 | 8 | 5230.11 | 111 | P2028 | female | white | Pennsylvania | Delaware | E039 | 0 | 6 | Outpatient | Approved | BCBS | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 300 | 6 | 10 | 2 | 1 | 418 |
| 5594 | 11224.21 | 1.0 | 78 | 4 | 11224.21 | 111 | 89250 | female | white | Pennsylvania | Delaware | R972 | 0 | 6 | Outpatient | Approved | BCBS | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 301 | 6 | 10 | 2 | 1 | 418 |
| 5595 | 11224.21 | 1.0 | 78 | 6 | 11224.21 | 111 | 85018 | female | white | Pennsylvania | Delaware | R42 | 0 | 6 | Outpatient | Approved | Medicare | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 305 | 6 | 10 | 2 | 1 | 418 |
| 5596 | 11604.91 | 1.0 | 78 | 2 | 11604.91 | 111 | 87040 | female | white | Pennsylvania | Delaware | S92901A | 0 | 6 | Outpatient | Approved | Medicare | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 306 | 6 | 10 | 2 | 1 | 418 |
| 5597 | 11224.21 | 1.0 | 78 | 1 | 11224.21 | 111 | 81005 | female | white | Pennsylvania | Delaware | F17200 | 0 | 6 | Outpatient | Approved | Medicare | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 307 | 6 | 10 | 2 | 1 | 418 |
| 5598 | 11439.31 | 1.0 | 78 | 7 | 11439.31 | 111 | 99100 | female | white | Pennsylvania | Delaware | E785 | 0 | 6 | Outpatient | Approved | Humana | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 370 | 6 | 10 | 2 | 1 | 418 |
| 5599 | 10714.01 | 1.0 | 78 | 6 | 10714.01 | 111 | 97530 | female | white | Pennsylvania | Delaware | E785 | 0 | 6 | Outpatient | Approved | Cigna | NOT_APPLICABLE | 0SRC0J9 | Replace of R Knee Jt with Synth Sub, Cement, Open Approach | 23 | 420 | 6 | 10 | 2 | 1 | 418 |